Summary Report
Spider Charts for Categories and Action
Overall
Gender
Prefer not to say
Female
None
Male
Age
Young
Middle-aged
Location
Belgium
UK
UK_London
Australia
Second-version of spider charts
Gender
Age
Location
Word-Cloud Open-Ended Question
Sentiment analysis
Emotions
When applied to text for emotion analysis, syuzhet first tokenises the input into words or sentences and then compares each token against a sentiment lexicon (the NRC lexicon in this case) that assigns each word to one or more of eight emotions. It can also produce a single polarity score, positive words increase the score while negative words decrease it, producing an overall numeric polarity value for the text.
NRC works well for short text. While it doesn’t capture intensity (for polarity for example) it also can capture up to eight emotions.
Raw count:
Normalised:
Polarity
Raw Count:
Normalised:
Qualititative Example
The code identifies a representative qualitative response for each classification category using TF-IDF (Term Frequency–Inverse Document Frequency). First, responses are filtered for the relevant sub-questions and cleaned to remove extra spaces and normalise text. Each response is then tokenized into individual words, and TF-IDF is computed for every word, treating each response as a separate document. By summing the TF-IDF scores across all words in a response, we obtain a score that reflects how distinctive and representative that response is within its category. Finally, the response with the highest TF-IDF score in each category is selected as the “Example,” and the total number of unique respondents per category is merged to produce a clean summary table.
| Classification | Count | Example |
|---|---|---|
| peace | 11 | curtail the russian government and stop their aggression towards other countries |
| the environment | 11 | environment |
| human rights | 8 | the priority should be freedom by choice. everyone should have the right to choose what they want to do. and this can be made possible by giving options and different opportunities. being obliged to do something is restrictive and can make for an authortarian regime. the freedom of choice can stretch for education to religion, transport, or employement. that is tolerance and not being restricted to not doing what you like because some other people are against it, should never be a problem. give people choice. |
| social cohesion | 7 | give humans equal rights, care about everyone’s safety, |
| education | 5 | accessible technology |
| housing | 5 | they should ensure a decent household for every inhabitants of the city, and guarantee access to basic needs (food, water, electricity) |
| poverty | 5 | price of salaries |
| international peace and stability | 4 | they need to help countury’s that are in war en make peace on earth |
| cohesion between people | 3 | create sustainable migration channels |
| inequality | 3 | stop inequalities |
| living standards | 3 | mor green |
| welfare provision | 3 | mor helping pepole |
| crime | 2 | security |
| health | 2 | equality, woman rights, reaching the sources, distribution of the sources according to priorities, prioritizing human health and public health |
| employment | 1 | be more open to homeless people for jobs so that they don’t have to struggle the same amount they do right now i think it will improve their lives because they get a second chance |
| local business and employment opportunities | 1 | they should invest more money in local business and focus on supporting their community |
| prosperity and growth | 1 | wealth |
| safety | 1 | save the planet |
| standards of living | 1 | i think they need to get their shit together and listen to what their citizens want |
| the economy | 1 | ensuring economic growth |
| the economy and prosperity | 1 | prioritise national interests by trading less with america and china |